﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using CardLogistics.Web.Components;
using System.Text;

namespace CardLogistics.Web.MainPage.CardRecovery.NotSaleCard
{
    public partial class NotSalecardDetailedRpt : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            string recoveryno = Request.QueryString["recoveryno"];//回收单号
      
            StringBuilder sbStr = new StringBuilder();
            sbStr.Append(" SELECT * FROM v_notsalecard_detail WHERE 1=1");
            sbStr.Append(" and Issubmit=5 ");//审核通过
            if (recoveryno.Trim().Length > 0)
                sbStr.Append(" and RecoveryNo like '%" + recoveryno.Trim().ToUpper() + "%' ");//回收单号
            sbStr.Append(" Order by RecoveryNo");

            OracleXMLReportData.GenNodeXmlData(this, sbStr.ToString(), true);
        }
    }
}